647.1 Introduction[//]

The loyalty program (Boekerpas) is a combination of cultural passport and books saving scheme for children under eighteen. Every child that is a member of the Library, receives a Boekerpas with a starting credit of 5 euro. Every time somebody with a Boekerpas borrows a book from the library, 10 cents are added to their account (with a maximum of 50 cents per week). The money saved in this way, can be used to buy children's and juvenile books in bookshops with up to 20% discount. Boekerpas holders can also get discounts on entrance fees for museums, films, theatre and other cultural activities for youth.

This AFO is the interface that exports data from the borrower and circulation databases into files, which are uploaded to the Boekerpas server.

647.2 Export[//]

When you choose this AFO, the following form will be displayed:

After enterig the required date information, the system will switch to the standard screen for scheduling processes.

This process will export the data to the folder that is defined in AFO 481 – Miscellaneous – Loyalty program.

The system will store until which date the export was generated.

New export files (one per day) will be generated for each day since the last date, but not including the current date. This implies that the process needs to be scheduled after midnight and will harvest the data for the previous day (and in rare cases other preceding days). The export files will also be kept in the system, so that they, in case of emergencies, can be recreated.

647.3 Data formats[//]

Export of the borrower data in XML

The file name will be constructed as follows:

·                “CUSTOMER”+_+CUSTOMERID+_+DATE+ _+DATESEQUENCE+.xml

·                CUSTOMERID is the interface library number (as defined in AFO 481)

·                DATE is in the format YYYYMMDD.

·                DATESEQUENCE consists of two digits and represents a sequence within each date. This will probably always be 01.

Example: CUSTOMER_12_20080902_01.xml

Export of the circulation data in XML

The file name will be constructed as follows:

·                CIRC+_+CUSTOMERID_+DATE+_+DATESEQUENCE+.xml

·                CUSTOMERID is the interface library number (as defined in AFO 481)

·                DATE is in the format YYYYMMDD.

·                DATESEQUENCE consists of two digits and represents a sequence within each date. This will probably always be 01.

Example: CIRC_12_20080902_01.xml

Notes

For the data that is written to the XML file, the following applies:

·                If the house number is not stored in a separate field in Vubis, it will be deduced automatically from the street field.

·                Initials, telephone, fax and email are not mandatory.

·                Date of birth will be in the format DD-MM-YYYY.

·                Gender is either M or F (or not present).

·                Transaction number is a unique number that is constructed as follows:

-                 YYYYDDMMxxxxxx, in which xxxxx represents a unique number within the specific date. The number is five digits long; leading zeros will be used to create a five digit number. [ This is not the Vubis transaction id.]